<?php
/*
$mysql_user = "TIS2user";
$mysql_pass = "resu2SIT";
$mysql_host = "localhost";
$mysql_db   = "TIS2";
$mysql_conn = "mysql://$mysql_user:$mysql_pass@$mysql_host/$mysql_db";

// Temporary store of courses
$course_array = array (
	//		Title												Category			Weight
	array (	"id" => 1,	"title" => "Theoretical and Statistical Physics",	"weight" => 1,	"url" => "http://www.gasda.com"),
	array (	"id" => 2,	"title" => "Relativity",							"weight" => 1,	"url" => "http://www.gasda.com"),
	array ( "id" => 3,	"title" => "Advanced Quantum Physics",				"weight" => 1,	"url" => "http://www.gasda.com"),
	array ( "id" => 4,	"title" => "Optics and Electorydynamics",			"weight" => 1,	"url" => "http://www.gasda.com"),
	array ( "id" => 5,	"title" => "Computational Physic",					"weight" => 0.2,"url" => "http://www.gasda.com"),
	array ( "id" => 6,	"title" => "Astrophysical Fluid Dynamics",			"weight" => 1,	"url" => "http://www.gasda.com"),
	array ( "id" => 7,	"title" => "Particle and Nulclear Physics",			"weight" => 1,	"url" => "http://www.gasda.com"),
	array (	"id" => 8,	"title" => "Quantum Condensed Matter",				"weight" => 1,	"url" => "http://www.gasda.com"),
	array ( "id" => 9,	"title" => "Soft Condensed Matter",					"weight" => 1,	"url" => "http://www.gasda.com"),
	array ( "id" => 10,	"title" => "Physics in Action",						"weight" => 1,	"url" => "http://www.gasda.com"),
	array ( "id" => 11,	"title" => "Physics Education (limited numbers)",	"weight" => 1,	"url" => "http://www.gasda.com"),
	array (	"id" => 12,	"title" => "Research Review",						"weight" => 1,	"url" => "http://www.gasda.com"),
	array (	"id" => 13,	"title" => "Computational Project",					"weight" => 1,	"url" => "http://www.gasda.com"),
	array (	"id" => 14,	"title" => "Experiment E1 & E2",					"weight" => 1,	"url" => "http://www.gasda.com"),
	array ( "id" => 15,	"title" => "Theory TP1 & TP2",						"weight" => 1,	"url" => "http://www.gasda.com"),
	array ( "id" => 16,	"title" => "Long Vacation project (approval)",		"weight" => 1,	"url" => "http://www.gasda.com")
);

// Temporary store of category (groupings)
$category_array = array (
	
);

$predicate_array = array ();

$terms_array = array (
	"M" => "Michaelmas",
	"L" => "Lent",
	"E" => "Easter"
);

$colleges__array = array (
	"Darwin",
	"Pembroke",
	"Peterhouse"
);

$students_array = array (
	array(	"ID" => 0,	"DoS" => 0	,"name" => "Bob Bloggs",	"choices" => array(1,2,3),	"status" => "unregistered", 	"college " => 1),
	array(	"ID" => 1,	"DoS" => 1	,"name" => "Jane Smith",	"choices" => array(1,3,4),	"status" => "pending approval",	"college" => 2),
	array(	"ID" => 2,	"DoS" => 1	,"name" => "Jane Smith",	"choices" => array(),		"status" => "unregistered", 	"college" => 2)
);

$triposes_array = array (
		//TriposID	TriposName						Start Academic Year		End Academic Year
	array("name" => "Part IA"),
	array("name" => "Part IB Physics",										"end" => 1151712000),
	array("name" => "Part IB Advanced Physics",								"end" => 1151712000),
	array("name" => "Part II ETP"),
	array("name" => "Part II Half Subject Physics"),
	array("name" => "Part III ETP"),
	array("name" => "Away at MIT"),
	array("name" => "Part IB Physics A",			"start" => 1185926400),
	array("name" => "Part IB Physics B",			"start" => 1185926400),
	array("name" => "Part II Astrophysics",			"start" => 1220227200),
	array("name" => "Part IIB Engineering",			"start" => 1220227200),
	array("name" => "Part III Earth Sciences",		"start" => 1220227200),
	array("name" => "Part III Chemistry",			"start" => 1220227200),
	array("name" => "Part III Materials",			"start" => 1220227200),
	array("name" => "Part III Astrophysics",		"start" => 1254355200)
	
);

$options_array = array (
	"half subject",
	"three year",
	"four year"
);

$registration_array = array (
	array( "regid" => "", "student_id" => 1, "tripos" => 7, "option" => 1)
);

$registration_status_array = array (
	"unregistered",
	"pending approval",
	"registered"
);

$DoS_array = array (
	array ("name" => "Jo Smith", "College" => 1),
	array ("name" => "Jack Taylor", "College" => 2)
);*/